Analytical Data Store

An Analytical Data Store (ADS) is a data storage architecture, designed to support complex analytical queries and reporting. While traditional databases are optimized for high-speed transactions, ADS is optimized for data querying, reporting, and analyzing large volumes of data.

Analytical Data Stores are designed to efficiently handle complex queries, aggregations, and analytics that involve indexing and partitioning. Since the schema is defined and the data is transformed before being loaded into the ADS, it optimizes data retrieval to support fast query performance. An ADS however supports structured data or may also support semi-structured data, but does not support unstructured data as supported by a data lake.

Due to optimized query performance, ADS is used for generating reports, dashboards, and visualizations to support decision-making related to business. It also facilitates predictive analysis and other advanced data analysis techniques. Cloud-based ADS solutions provide scalability to handle increasing data volumes and query loads.

The Lazsa Platform lets you configure the connection details of various supported Analytical Data Stores as an RDBMS:

Amazon RDS for MySQL
Amazon RDS for PostgreSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Snowflake

See Configure RDBMS Connection Details

The Analytical Data Store (ADS) tools are used in data visualization pipelines in Data Pipeline Studio.